Page Control Search – Dynamics 365 BC Table Reference

SELECT p.ID ,p.Name ,pc.ControlName ,post.post_name FROM azrcrv_PageControls AS pc INNER JOIN azrcrv_Pages AS p ON p.ID = pc.PageNo INNER JOIN bct_posts AS post ON post.post_title = p.Name WHERE pc.ControlName = 'Ship-to Address 2' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to SHIP-TO ADDRESS 2

Seq No	Page Number	Page Name	Control Name
1	1	Company Information	Ship-to Address 2
2	1	Company Information	Ship-to Address 2
3	41	Sales Quote	Ship-to Address 2
4	42	Sales Order	Ship-to Address 2
5	43	Sales Invoice	Ship-to Address 2
6	49	Purchase Quote	Ship-to Address 2
7	50	Purchase Order	Ship-to Address 2
8	51	Purchase Invoice	Ship-to Address 2
9	52	Purchase Credit Memo	Ship-to Address 2
10	88	Job Card	Ship-to Address 2
11	130	Posted Sales Shipment	Ship-to Address 2
12	132	Posted Sales Invoice	Ship-to Address 2
13	134	Posted Sales Credit Memo	Ship-to Address 2
14	136	Posted Purchase Receipt	Ship-to Address 2
15	138	Posted Purchase Invoice	Ship-to Address 2
16	140	Posted Purchase Credit Memo	Ship-to Address 2
17	507	Blanket Sales Order	Ship-to Address 2
18	509	Blanket Purchase Order	Ship-to Address 2
19	5159	Sales Order Archive	Ship-to Address 2
20	5162	Sales Quote Archive	Ship-to Address 2
21	5164	Purchase Quote Archive	Ship-to Address 2
22	5167	Purchase Order Archive	Ship-to Address 2
23	5900	Service Order	Ship-to Address 2
24	5933	Service Invoice	Ship-to Address 2
25	5935	Service Credit Memo	Ship-to Address 2
26	5964	Service Quote	Ship-to Address 2
27	5972	Posted Service Credit Memo	Ship-to Address 2
28	5975	Posted Service Shipment	Ship-to Address 2
29	5978	Posted Service Invoice	Ship-to Address 2
30	5980	Service Item Card	Ship-to Address 2
31	6050	Service Contract	Ship-to Address 2
32	6053	Service Contract Quote	Ship-to Address 2
33	6072	Filed Service Contract	Ship-to Address 2
34	6620	Blanket Sales Order Archive	Ship-to Address 2
35	6623	Blanket Purchase Order Archive	Ship-to Address 2
36	6627	Sales Return Order Archive	Ship-to Address 2
37	6630	Sales Return Order	Ship-to Address 2
38	6640	Purchase Return Order	Ship-to Address 2
39	6644	Purchase Return Order Archive	Ship-to Address 2
40	6650	Posted Return Shipment	Ship-to Address 2
41	6660	Posted Return Receipt	Ship-to Address 2
42	41002	Hist. Sales Trx. Headers	Ship-to Address 2
43	41007	Hist. Sales Trx.	Ship-to Address 2

Dynamics 365 BC Table ReferencePage Control Search